package com.kedi.journalismcenter.read.dao.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 
 *
 * @author: 	陈辽逊
 * @date: 		2019/7/13 11:01
 */
@Mapper
public interface ReadGoldenRadioMapper {
	
	/**
	 * 			 	 获取评书所有数据信息
	 * @return		 返回一个封装数据对象storytelling
	 */
	
	@Select("SELECT COUNT(storytel_id) as total_size,* FROM storytelling"
		    + "LIMIT  #{page},#{limit};")
	List<Map<String, Object>> storytelling(@Param("page")int page,@Param("limit")int limit);
	
	/**
	 * 				 获取戏曲所有信息
	 * @return		 返回一个数据对象opera
	 */
	@Select("SELECT COUNT(opera_id) as total_size,* FROM opera"
			+ "LIMIT  #{page},#{limit};")
	List<Map<String, Object>> opera(@Param("page")int page,@Param("limit")int limit);
	
	/**
	 *				  获取音乐所有信息
	 * @return       返回一个封装数据对象
	 */
	@Select("SELECT COUNT(music_id) as total_size,* FROM music"
			+ "LIMIT  #{page},#{limit};")
	List<Map<String, Object>> music(@Param("page")int page,@Param("limit")int limit);
	
	/**
	 *				  获取实评所有信息
	 * @return		 返回一个封装数据对象review
	 */
	@Select("SELECT COUNT(review_id) as total_size,* FROM review"
			+ "LIMIT  #{page},#{limit};")
	List<Map<String, Object>> review(@Param("page")int page,@Param("limit")int limit);
}
